共计 408 个字符，预计需要花费 2 分钟才能阅读完成。
报错详情
mysqldump: couldnt execute select column_name, json_extract(histogram, $.number-of-buckets-specified) from information_schema.column_statistics where schema_name = dblog and table_name = biz_article;: unknown table column_statistics in information_schema (1109)
问题定位
提取关键错误信息，如题所示：unknown table column_statistics in information_schema (1109)
查看本地mysql的下载版本是8.0版本
![[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！](https://peiluming-blog.oss-cn-shanghai.aliyuncs.com/oneblog/20230607190646775.png "[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！")
经查询StackOverFlow，解决方案是版本较高，部分参数需要手动添加调整
![[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！](https://peiluming-blog.oss-cn-shanghai.aliyuncs.com/oneblog/20230607191618027.png "[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！")
解决方案
导出步骤：
![[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！](https://peiluming-blog.oss-cn-shanghai.aliyuncs.com/oneblog/20230607191734961.png "[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！")
问题解决方式，设置参数
![[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！](https://peiluming-blog.oss-cn-shanghai.aliyuncs.com/oneblog/20230607191951083.png "[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！")
完美解决
报错问题没有再出现
![[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！](https://peiluming-blog.oss-cn-shanghai.aliyuncs.com/oneblog/20230607192115821.png "[DataGrip]MySQL数据备份报错，mysqldump: unknown table column_statistics in information_schema (1109) ，解决！")
正文完
